Printing Cost of Goods Sold

The Cost of Goods Sold Batch Preview Report and Cost of Goods Batch Report print the same information. If the Cost of Goods Sold process is run as part of the Close End of Day process two reports are generated : the Cost of Goods Batch Report for both the costed and uncosted items and the Uncosted Items Report for just the uncosted items.The report is broken down into two sections for each item: the lots used to value the inventory and the lots assigned to each sales order lines.

The following information is included on the report:

Header:

Batch Preview - If the report is a Batch Preview Report or an Uncosted Report from EOD, or the Batch Number for the cost of goods batch

The Date and time the batch was created

Body:

Lot Section:

• Item – The item code and item name of the costed item.
• Date - The Date the lot was created.
• Time - The time the lot was created.
• Loc - The location for lotted items.
• Lot Number - The lot number.
• Quantify Costed - The quantity costed for the lot.
• Before Costing Quantity - The beginning lot balance before cost of goods was run.
• Before Costing Unit Cost - The unit cost and unit of measure for the lot prior to running cost of goods.
  • If the lot is on costing hold, "hold" will appear in this column to indicate the lot is on costing hold. The reference number for the transaction on hold will appear in the After Costing Unit Cost column.
• After Costing Quantify - The ending balance for the lot after cost of goods was run. If the quantity in the lot is zero after costing the after quantity column will be blank.
• After Costing Unit Cost - The ending unit cost and unit of measure after cost of goods was run. If the unit cost is zero the column will be blank.

Sales Order Line Section

• Margin – The gross margin for sales order line. The method used to calculate the gross margin is defined in Ledger Options.
• Price – The net selling price for the product after all cost allocations.
• Other – The other price or pricing exceptions applied to the item.
• Cost – The per unit cost that was applied to the item.
• Customer – The customer ID code.
• Order – The sales order reference number.
• Date - The Date the sales order was shipped.
• Time - The time the sales order was shipped .
• Loc - The location for lotted items.
• Lot Number - The lot number assigned to the sales order for costing purposes.
• Quantify Costed - The quantity costed for the lot assigned, followed by "Costed" to indicate the sales order line costed and the unit cost applied to the sales order If the item will not cost the following will appear:
  • Unavailable - there are no lots available to apply to the sales order line. The sales order line will cost once there is enough non-hold inventory available to cost the sales order line.
  • Skipped - there is not enough ready or non-hold inventory available to cost the sales order line. The sales order line will cost once there is enough non-hold inventory available to cost the order.
  • Purchase Order xxxxx not completed - the sales order line will not cost because the item is on a purchase order that has not been completed. The sales order line will cost once the purchase order is completed.
  • Work Order xxxxx not costed - indicates that the sale order line will not cost because the work order that created the item is not costed. This is usually a result of the raw material used on the work order is from a lot that is on hold because the purchase order has not been completed. Once the purchase order is completed, the work order will be costed and the sales order line will cost the next time cost of goods is run.
  • Transfer xx/xx xx not costed - Indicated the Inventory Transfer used to create the item is on hold. This is usually a result of the 'From" item on the transfer being on hold because the purchase order for the "From: item has not been completed. Once the purchase order is completed, the transfer will be costed and the ales order line will cost the next time cost of goods is run.

Totals will display for:

• Posted $ – The cost assigned to posted invoices.
• Unposted $ – The cost assigned to the order that have not been invoiced or have been invoiced but not posted.

For more information on the Cost of Goods Sold option see Cost of Goods Sold.

Security Required : Inventory - Cost of Goods Sold